package com.sanhuo.idms.dao;

import com.sanhuo.idms.entity.RepairTask;
import com.sanhuo.triild.Basic.BaseMapper;
import com.sanhuo.triild.annotation.Mapper;
import com.sanhuo.triild.annotation.Select;

import java.util.List;

@Mapper
public interface RepairTaskMapper extends BaseMapper<RepairTask> {

    @Select("select count(*) from repair_task where personalId = #{personalId}")
    Integer countNum(String personalId);

    @Select("select repairId from repair_task join repair where personalId = #{personalId} and repair_task.repairId = repair.id")
    List<String> findRepairIds(String personalId);

}
